package com.woniuxy.classteacher.mapper;

import com.woniuxy.commons.entity.CollegeEntranceScore;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * @Auther: 牟强
 * @Date: 2020/7/20/020 14:21
 * @Description:
 */
@Repository
public interface StudentInfoMapper {
    /**
     * @Author: 牟强
     * @Date: 2020/7/21/021 11:11
     * @Description: 通过学生id查询学生姓名
     * @Param: [stuId]
     * @return: java.lang.String
     */
    public String findStudentNameBySId(int stuId);

    /**
     * @Author: 牟强
     * @Date: 2020/7/21/021 11:16
     * @Description: 计算学生与对应班级的数量
     * @Param: [stuId, classId]
     * @return: java.lang.Integer
     */
    public Integer computeStudentAndClassNum(@Param("stuId") int stuId, @Param("classId") int classId);

    /**
     * @Author: 牟强
     * @Date: 2020/7/21/021 15:08
     * @Description: 修改学生班级
     * @Param: [stuId, classId]
     * @return: void
     */
    public void updateStudentClassIdBySutdentId(@Param("stuId") int stuId, @Param("classId") int classId);

    /**
     * @Author: 牟强
     * @Date: 2020/7/21/021 17:36
     * @Description: 批量添加高考分数
     * @Param: [collegeEntranceScores]
     * @return: void
     */
    public void batchAddCollegeEntranceScore(List<CollegeEntranceScore> collegeEntranceScores);

    /**
     * @Author: 牟强
     * @Date: 2020/7/27/027 11:51
     * @Description: 根据学生账号查找id
     * @Param: [account]
     * @return: java.lang.Integer
     */
    public Integer findStudentIdByStudentAccount(String account);


}
